Round 1: Technical Interview

Introduction:

🔹Brief self-introduction.

🔹Discussion of current role and responsibilities.

🔹Current Project Architecture:

🔹Questions focused on the architecture of your current project, specifically involving Informatica and Snowflake.

Snowflake Topics:

🔹Snowpipe: Explanation and a working example.

🔹Stream and Task: Use cases and functionality.

🔹Time Travel: Concepts and practical scenarios.

🔹Delete vs. Truncate: Differences and when to use each.

SQL Concepts:

🔹Queries involving Joins, GROUP BY, and RANK.

🔹Techniques to identify and handle duplicate records.

Other Snowflake Concepts:

🔹General discussion of additional Snowflake features and best practices.

Round 2: HR + Managerial Interview

Behavioral Questions:

🔹General questions to assess cultural fit and teamwork abilities.

🔹Discussion of past challenges and resolutions.

Project Insights:

🔹Discussion about the upcoming project, its scope, and typical workflows in the organization.

Salary Discussion:

🔹Negotiation and discussion of compensation expectations.